I can only speak from a personal perspective.
My opinion is that most peoples desire in Scotland pro or against independence is not driven by financial or economic matters but what's inside them personally.
For me I am a Scottish resident, English born of a Scottish Mother and English Father. As British as its possible to get i suppose. I have lived in Scotland for about 46 of my 53 years. My first 2 then a 5 year period 1998-2003.
Two of my five children are English born, the other three Scottish.
The SNP get their way, they make me foreigner in my own country.
Not if I have anything to say about it!
That said, my experience of talking to pro-independence minded people is that they also don't care about financial and or economic consequences.
Freedom at any price is the usual mantra I have come across.
For most of the past 20 years the SNP has been led by 2 very charismatic leaders who engaged with Scotland. That is now gone.
The next General Election, probably in just over a year will be very interesting.
Edited to add: I do however support the right of Scotland to determine this if the majority vote for it in an election which gives a mandate for a further referendum.
But like the 2014 one, I don't think a Yes vote is a foregone conclusion.